import pymysql
from pyecharts import options
from pyecharts.charts import Bar

#连接数据库
db=pymysql.connect(
    host="localhost",
    user="root",
    password="12345",
    database="crawlerdemo",
    charset="utf8"
)

cursor=db.cursor()
sql="select min(job_sal),job_place from job group by job_place order by min(job_sal) limit 5"

sal=[]
city=[]

try:
    cursor.execute(sql)
    res=cursor.fetchall()
    for i in res:
        sal.append(i[0])
        city.append(i[1])
except Exception as e:
    print(e)
    print("查询出问题")
#创建柱状图
bar=Bar()
#
bar.add_xaxis(city)
#添加y轴的数据
bar.add_yaxis("月薪水/元",sal)
bar.set_global_opts(title_opts=options.TitleOpts(title="五个城市的最低工资",subtitle="单位/元"))
bar.render("barmin.html")

cursor.close()
db.close()